SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vw_SubsidiosOAportes
AS
SELECT idSubsidioOAporte, expediente+'-'+resolucion+'-'+convert(varchar,plazodevencimiento) as mnemo, Expediente, PlazoDeVencimiento, 
    Resolucion
FROM dbo.tb_SubsidiosOAportes

GO
GRANT SELECT ON  [dbo].[vw_SubsidiosOAportes] TO [SoloVer]
GO
